Mineral rights here in AL were teased out years ago by quietly reverting back to the State unless the last owner (of mineral rights) included with deed upon sale. I checked when I bought back here. They can be had here, (purchased back from the State) but it will cost you..
You can dig a pond here as big as you want, but I think they want a permit. They're more interested in what you put into a pond than what you pump out..
As for pumping the aquifer out for commercial use, (like Poland Springs in Maine) I don't know. I think it could be done, quietly, on a small scale at first, only because Al. is pretty business friendly.
Generating electricity? Probably not.. The TVA doesn't like competition..
I really don't think one would have trouble with a cistern here, as big as one could make it on, a residential level.
The price of municipal water has doubled here like every place else east of Kansas in the last few years..