What's the price of your water? As in $/cf or $/gallon. Then estimate how many times it rains and would fill your barrel/year. Does a rain barrel make sense still?
I did the math and estimated I can save about $1/year/barrel for each water barrel I install. Sure I can install multiple barrels in a row, I just pay for some connectors and barrels. It might only cost $20 for the barrel and connectors, barrels are listed online for $15-20, maybe I can find a better deal. It's still a 20 year payback for me, if everything goes according to plan. Currently I'm on the lookout for free supplies, I don't mind waiting.
I wouldn't use storm sewer runoff, in my area it contains elevated levels of salt, oils, pesticides, herbicides and whatever else people decide to dump. Over the long term those things accumulate and can be toxic to plants.