Pre-Y2K, I purchased around 5-6 different water storage jugs. I filled them, secured the lids/spouts/caps, and tipped them on their sides. Some immediately leaked. Others leaked overnight. Only the Aquatainer bottles remained leak free. I returned the others and stocked up on Aquatainers.
All my transportable home water is now in Aquatianer jugs (Non-transportable water is in 55 gallon food grade plastic drums). I purchased the 7 gal Aquatainer to minimize the number of jugs needed, but the filled weight is close to 50 lbs (7 lbs/gallon). I can haul it around now, but might struggle if I were injured or ill. If I was starting over I would opt for the 4 gallon size. The Aquatainer jugs are designed to allow stacking too. Decent spigot.
I use the Colman 5 gal jugs for camping (very convenient to use the spigot when tipped on its side), but have had some problem with leaking spigots and o-rings. I just ordered up a bunch of replacement parts from Coleman to keep these running. I don't think the Colman jugs were designed to allow stacking (though, I've never tried).
The standard collapsible water containers can and will leak (personal experience). These are convenient for some uses, but not relialble enough for me to consider.
If you want smaller containers, Nalgene is superb gear. I have no experience with the camelback style bladders.
Happy Hydration, TR