Atlanta came annoyingly close a few years back. There are _no_ natural lakes in GA; the two artificial lakes are big, but are susceptible to draining during prolonged droughts. (The Corp Of Engineers failing to notice their depth gauge was busted, when the lake was OBVIOUSLY running low, didn’t help.)
Georgia was engaged in a legal battle to try and get their border with Tennessee moved 600 feet to the north so that they could tap a reservoir.
No idea where that case stands.