People have a fetishization with hyping up disappearing water sources as leading to mass forced desertions of population centers, which is not rooted in any kind of reality.
We can already pipe oil from texas to Canada with ease, we can do the same from Canada to Arizona with water. Or wherever else. The economics and viability of it is obvious and clear.
Residents of water scarce areas would pay marginally higher taxes to support this