The solution is simple. Keep raising the price of water until the water usage drops to a sustainable level. No need for government to pick winners and losers, just let the market do it. That will lead to the most efficient outcome. Remove any subsidies or special rights to water that anyone has and just make it a single unified market.