Don't bother with expensive water containers.
http://www.amazon.com/Reliance-Products-Desert-Traditional-Container/dp/B0002IW6IY/ref=sr_1_6?ie=UTF8&qid=1427345957&sr=8-6&keywords=reliance+water+containers
I have like six or seven of these. You can get them at Walmart for around $15. Six gallons is enough for me, my fiancee, and two dogs for around 3-4 days in the forests of NW Montana. If you need more, well then it's only another $15. Very tough, very light, and comes with it's own spout that happens to be the perfect size for a narrow-mouth Nalgene bottle.
Another AquaTainer user. 5Gal, Nice and square, easy to pack around, and basically won't leak if you store it upright. Family has been using them for over 30 years now, and never had any issues. Summer in the truck, winter on the the sleigh behind the snowmachine. Unless you have onboard storage, or a specific need to keep it on the back of your vehicle in a Sceptre container holder I can't see a better solution.
https://www.relianceproducts.com/products/hydration/187.html
Edit: After reading the post above, I guess I could see in a dusty environment how they might rub through over enough time. Ours have exhibited some wear over the years, but I think we've only ever replaced them once or maybe twice in the last 25 years I can remember camping with my family, and not due to a failure on a trip. The plastic certainly isn't as robust as a Sceptre or similar.
You're better off with the supermarket juice jug solution
That's the container I've been using for years - I've got 2 of them.
They're not the same Reliance containers as mentioned in the above post regarding the spigot (nice product that one). These square blue Reliance containers have a spigot built into the cap. The caps will drip when the container's on its side with 5+ gallons inside. So, it's not perfect but it's pretty good as long as you can deal with the square-ish form factor.
I forgot to mention that the real LCI Products 20L jugs went up to $40/, unfortunately (but it's to a good cause sort of). .
I use Scepter jerry cans made for water; never leak, water doesn't taste bad.