Next up: Las Vegas
The next one is likely Utah, they are drying up the Great Salt Lake for alfalfa production, producing the next Owens Lake, likely making Salt Lake City and other cites unhabitable within a decade or two.
My money would be on Dubai.
Cape Town is already there.
Las Vegas is actually very efficient with their water use.