Most of the Camelbaks for cycling are 2L / 70oz, which should be good for several hours.

It's pretty easy to refill a Camelbak while you're on the road, so I don't think you need to go bigger than that.

FYI throw in a bunch of ice cubes, and the water will stay cooler much longer than insulated bottles.