This research examines the integration of geological and hydrogeological data in numerical aquifer model simulations, with a particular focus on the urban area of Torino, Italy. The role of groundwater resources in urban sustainability is analysed. The objective is to integrate open-loop geothermal plants into the district heating network of IREN S.p.A. Two case studies are examined: the Torino Nord area and the Moncalieri area, both of which host district heating plants. The work entails the collection and analysis of data from a variety of sources, including geognostic surveys and permeability tests, in order to construct a three-dimensional numerical model of the surface aquifer. Models were built using the public MODFLOW 6 (model of groundwater flow) code and calibrated using PESTHP (High Performance of Model Independent Parameter Estimation and Uncertainty Analysis). Results indicate the potential of urban aquifers as renewable energy sources and the necessity of comprehensive geological and hydrogeological assessments for optimal ground water heat pump (GWHP) system installation. This paper emphasises the significance of sustainable water management in the context of climate change and urbanisation challenges.