> Districts become disinsentivised to reduce the water use for their highest using customers because thats where they make the most revenue

Good! Now build a desalination plant and turn that into guilt-free income!