As always when it comes to these fixes, who's gonna pay for it?

You could raise the price of water to try and force people.... and then get slaughtered in the next election cycle. And that assumes you *can* force people. You can't. People don't have water leaks for fun, it's because they don't have the money to fix them. Or their apartment owners who don't care because they make the renter pay.