I've seen there's some outrage about Georgia "mansions" using what
some consider exorbitant amounts of water.

Do they not charge for water in ever increasing amounts per gallon as the
total number increases? As in, use a reasonable amount of water and pay X
per gallon. Use an excessive and start paying a higher per-gallon rate, at
an increasing percentage.