Sustainable water management in urban areas, especially under water scarcity, requires integrating innovative solutions with local practices. This work proposes reactivating medieval cisterns in the Historical Village of Castelo Rodrigo—centuries-old structures once essential to the community's water supply and now inactive. The initiative aims to recover these infrastructures to store and use rainwater for non-potable purposes such as firefighting, urban cleaning, and supply to local infrastructures, promoting decentralised and efficient water use. The methodology includes a technical assessment of the cisterns, identifying potential uses for stored rainwater, and developing a local management model. Additionally, it supports historical heritage preservation and enhances its tourism potential. By reviving traditional water management practices, the proposal reinforces community engagement with sustainability and environmental protection. The expected results include increased local water resilience, reduced environmental impact and the valorisation of heritage infrastructure as key elements of equitable and sustainable water management. This model is scalable to other similar contexts, especially in regions with climate and water scarcity challenges, such as the Mediterranean. By combining innovative solutions and historical practices, the proposal presents a viable way of transforming urban paradigms and adapting them to the demands of the twenty-first century. This study proposal aims to highlight the relevance of adapting heritage water infrastructures to contemporary uses and standards of efficiency and quality. This contributes to climate adaptation and strengthens resilient and water-sensitive communities.