I feel the OP's $$ pain (no joke).
Another concern is salt water encroachment, like salt water seeping into aquifer. At risk are areas having high permeable aquifers like rounded grain sand being exposed to previous effects of weathering, adjacent to salt water that are subject to extensive draw downs. Like salt water replacing fresh water. Solutions being extensive municipal watersheds or an aqueduct.
A long time ago we lived in an area where well drilling was risky. This guy who was super big money ($zillions) moved in and his solution was to build a private desalination plant that sucked up salt water from a adjacent tidal river, many $$. Among other things he filled a swimming pool with fresh water.
I am real olde now and have city water at my house & pay an average of 65 per month including sewer use. I have a nice green lawn. Way back then I paid about $10 K to drill a 350 ft well in granite to get about 25 gpm @ 25 psi. Hydro fracking at granite fracture zones helped. Lucked out with good water having no sulphur smell.