I prefer to drink air temperature water, so I don't worry about keeping it cold. Too much cold water sometimes gives me a stomachache, on a hot day, so I can't drink it as fast. Also cold water bottles will sweat in your tank bag and get your other stuff as wet as if they had leaked. I have a couple of those Camelback water bladders that I use on trips, and I don't have too much trouble with the bite valves. The secret trick to keep them from getting nasty when stored, is to store them empty in the freezer.
When I'm not covering long distances, I just re-use random water bottles from the convenience store, or buy new ones. I haven't had trouble with leaks, and there's no condensation when they aren't cold. I don't drink from them while riding. The difficult part, when I have to buy new water bottles, is that it's hard to get one that isn't refrigerated.
Another way I have seen people carry water, that looks effective, is to strap a thermos or other jug on the passenger seat, or on the footpeg, and run a tube like the ones used for camelbacks.
If you are using a camelback and like your water cold, the trick is to blow back into the tube when you are finished with your drink, so the water doesn't sit in the tube and get warm.