Mexico, as many countries, relies on its aquifers to provide at least 60% of all irrigation water to produce crops every year. Often, the water withdrawal goes beyond what the aquifer can be replenished by the little rainfall. Mexico is a country that has experienced a successful process of regional development based on the adoption of intensive agricultural systems. However, this development has occurred in an unplanned way and displays shortcomings in terms of sustainability, particularly in the management of water resources. This study analysed the case of Costa de Hermosillo, which is one of the Mexican regions in which this model of intensive agriculture has been developed and where there is a high level of overexploitation of its groundwater resources. Based on the application of a qualitative methodology involving different stakeholders (farmers, policymakers, and researchers), the main barriers and facilitators for achieving sustainability in water resources management have been identified. A series of consensus-based measures were contemplated, which may lead to the adoption of sustainable practices in water management. Useful lessons can be drawn from this analysis and be applied to other agricultural areas where ground and surface water resources are overexploited, alternative water sources are overlooked, and where stakeholders have conflicting interests in water management.