Raising the rates for the right parties is what we should really be talking about but the question then is, who? Small farms and industry would be hit very hard but the ones with deep pockets likely wouldn't blink and they're the biggest problem.
In my opinion it would need to be a sliding scale. Not just a "$x for n gallons" pricing structure but the more you use the greater the cost per gallon. That would hit the biggest users the hardest while leaving the average person unaffected (unless for some reason they're using absurd amounts in which case they need to be affected).