The Socioeconomic Dimensions of Water Scarcity in Urban and Rural Mexico: A Comprehensive Assessment of Sustainable Development Academic Article in Scopus