i have a few regular 5 gallon pails with watertight lids that i picked up from the local hardware store. my building uses water softener, and when i drink the water from the faucet, i am still thristy. i have a spring that bubbles out the the side of the hill near my house, and i go there and fill the 5 gallon pails with water and bring them home. i keep water bottles in the fridge, and refill them straight out of the pail by submerging them in the buckets. low tech, but it works just fine. and the water tastes GREAT, too.
i see no reason why you cant use them for water storage straight out of the tap as well. just make sure the pails are rated for food storage.