I have found that the seams on most milk and water jugs tend to split over time. Two liter soda bottle last much longer.
Also filling your barrels with a hose do yourself a favor and buy a food grade hose. You can find them in most RV suppliers and even in the auto department at ‘wally world’.
Most of the milk-jug style distilled water containers I’ve bought have leaked before their expiration dates.
The 2.5 gallon rectangular spring water jugs develop pinholes over time...about two years I think, so they're useless. I haven't had any trouble with the standard 1-gallon plastic jugs (yet?).