I don't know about the US, but it's been law in the UK since at least the 1970s. Never known it to be enforced for a water barrel, though. If you build a property in the UK with its own natural water supply you're still liable to pay water rates.