Some US states have laws preventing rainwater capture. Water rights being a weird and complicated thing.
It's unlikely that a given residential area is drawing water from the area directly beneath it, or that its water supply is fed by residential run-off. That's not going to be clean water that you'd want to drink. Most residential water comes from resovoirs fed by mostly unpopulated catchment areas which are often 10s or 100s of miles away. Also bare in mind that around 50% of rainwater evaporates or ends up in the ocean, so there's plenty to go around.
I thought that the idea of rainwater capture was to prevent the water from going to "waste" as runoff. That is, the water that hits the roof of your house ends up in a torrent in the downspouts, which runs into the streets and the sewer system. Whereas the water that hits your yard has more of a chance to sink into the water table.
I'm not arguing against the idea, especially as it is typically implemented in the UK where a house will generally only have about 500 litres of storage, but scaling it up and making it a requirement could cause some interesting problems.