I'd watch the various Great Plains aquifers. I think the main outcome of drying isn't going to be thirst, but hunger, and that's the area to keep your eye on for when that'll really kick into high gear. Those aquifers were on track to dry up absent climate change, AFAIK, from severe overuse by agriculture.