Can you drive a reasonable distance to a body of water and fill up a water tank? Then you could use a siphon to unload it into barrels at home.
Or, if the water restrictions are seasonal, fill up your tank with the local supply when the season isn't dry.
I use a Brute 32-gallon trash can to store water for my garden. I fill it up with the hose a few times per year. It handles outdoor conditions well and was less expensive than alternatives. Don't know if it's safe for drinking water, but I don't use it for that.
I also have three 5-gallon glass carboys I used to use for winemaking. If I ever get around to making a darkroom in my shed I might use those mounted up high along with a vinyl tube siphon.