Florida geothermal systems pull cool water from the aquifer, use it for A/C and return it via a 2nd well. They're about the only wells that water management districts will rubberstamp.
Geothermal cooling (in FL) becomes cost efficient above 15k-20k sq ft (based on my 2010s exp). That led me to an idea that neighborhoods could be cooled by small geothermal utilities. I wonder about increased heat energy down the line but I've seen a doz+ chillers work efficiently, from one 4" well. On a larger scale, downstream heat buildup might be mitigated via a more distributed water system.