For bottled water my experience has been mostly with the bottled water that the local Porsche dealer stocks in a refrigerated cabinet in the sales area. I can't recall the brand: Crystal Geyser maybe?; but the bottle holds around 16 ounces and is small in diameter and its shape cylindrical so it fits cup holders well. I have one of these bottles in the fridge at home filled with water to put in the holder on my bicycle when I go for a ride in the evening.
For my cars I used to use the Porsche Thermal Mug filled with ice and water. It has a good cap that doesn't leak and it is very good at keeping fluids cold (or hot) for a long time. But I put it to work at home as my coffee "mug". It keeps the coffee so hot -- even with the lid off -- that I have to drop in an ice cube to cool the coffee down so I can drink it in time to leave the house for work.
Kind of pricey, but sometimes dealers offer these at a discount to clear out stock. The SA at the local dealer gave me one, left it in its box on the seat of the car one day when I picked up the car. Link below:
[
www.delawareporscheparts.com]
Nowadays for drinking water I use a thermos mug that I bought at Walmart. This:
[
www.walmart.com]
Like the Porsche thermal mug it too is very good at keeping water cold. I fill one up with ice cubes and water before I leave the house in the morning for work and when I get at the office I leave the mug in the car -- out of the sun -- and it still has ice and water in it at night when I leave for home. It is a little bit bigger than the Porsche coffee mug though and so I don't know if it would fit in your car's cup holders.