Can't beat the white Camco's for price. I had one of the flat hoses that come with a reel (see Camping World) that worked for 4 years and this year when I hooked it up it was full of pin holes, but I might still get a replacement hose as the reel is still good. Efficient use of space but durability is not ideal. I also just got one of these new clear all-weather hoses that are safe for drinking water. They also go flat and roll up. They are much more expensive than the Camco hoses, but roll up compact and have a 10 yr warranty.
Home Hardware - 5/8" x 25' All Season Clear Garden Hose
Definitely get 2 - 25ft hoses rather than one 50ft as it will save you rolling up 25ft of hose most every time you hook up the water. If you have space a 10ft hose is the one you will probably use most at serviced sites.