Enhancing Water Governance for Climate Resilience: Arizona, USA—Sonora, Mexico Comparative Assessment of the Role of Reservoirs in Adaptive Management for Water Security