We built our house 5 years ago and included a rainwater harvesting system, just the most basic one trhat was available. It was just future proofing in case water does get metered at some point in Scotland. We only connected it to all our toilets (3) and the washing machine, plus one tap in the garage. It is not treated, but filtered only. If the tank is empty (or system is not in use) the header tank gets filled from the mains and you won't know any different.
We have found that it doesn't work very well, and the filters keep blocking meaning that the toilets do not get re-filled..., so now we have turned it off and unless/until water gets charged for we just use the mains. (We are in Scotland and have enough rain to not feel guilty about using mains water for flushing the loo and other uses that would not need treated water.) Our toilets have half-fill opions, and we don't have baths, so I think we do not use that much water...