Current and future water availability: public opinion in the southern United States