To my knowledge, using rainwater in the house is rather not worthwhile or only with a very very long payback period. More expensive than the drinking water costs are the wastewater costs, and you have to pay those anyway.
At the beginning of the year, I was considering whether to get 2-3 IBC containers for garden irrigation. I then calculated what 3 containers with a pump and connection sets with some cladding would cost me. I came to about €400 without cladding and €600 with some wood around if it should look a bit nice. If I could save maybe 2/3 of my last year’s consumption of 30m³, that would be a lot. I watered the lawn almost every day since it was extremely dry and hot here last year for a long time. You can even sometimes get exempted from wastewater charges for the outdoor water tap. Unfortunately, with us, only from 93m³ with 3 people. I needed that much including irrigation, so I can only offset the saved drinking water costs of about €2.50/m³ and would come to €50 with 20m³ per year. So at least 12 years payback time. For that, you need the space for the 3 containers. For me, the tap is simply more comfortable. Turn it on and that’s it. Also, the water pressure here in summer is so high that I can reach exactly from one side to the other with our sprinkler. I probably would not manage that with a pump and would have to move the sprinkler several times.
I find the fancy rain barrels for €200 and more for 300l interesting. You probably need more than 40 years until they pay off. Whether they will even still exist then is doubtful.