Green hydrogen production is expected to play a major role in the context of the shift towards sustainable energy stipulated in the Fit for 55 package. Green hydrogen and its derivatives have the capacity to act as effective energy storage vectors, while fuel cell-powered vehicles will foster net-zero emission mobility. This study evaluates the potential of green hydrogen production in Power-to-Gas (P2G) systems operated in former mining sites where sand and gravel aggregate has been extracted from lakes and rivers under wet conditions (below the water table). The potential of hydrogen production was assessed for the selected administrative unit in Poland, the West Pomerania province. Attention is given to the legal and organisational aspects of operating mining companies to identify the sites suitable for the installation of floating photovoltaic facilities by 2050. The method relies on the use of GIS tools, which utilise geospatial data to identify potential sites for investments. Basing on the geospatial model and considering technical and organisational constraints, the schedule was developed, showing the potential availability of the site over time. Knowing the surface area of the water reservoir, the installed power of the floating photovoltaic plant, and the production capacity of the power generation facility and electrolysers, the capacity of hydrogen production in the P2G system can be evaluated. It appears that by 2050 it should be feasible to produce green fuel in the P2G system to support a fleet of city buses for two of the largest urban agglomerations in the West Pomerania province. Simulations revealed that with a water coverage ratio increase and the planned growth of green hydrogen generation, it should be feasible to produce fuel for net-zero emission urban mobility systems to power 200 buses by 2030, 550 buses by 2040, and 900 buses by 2050 (for the bus models Maxi (40 seats) and Mega (60 seats)). The results of the research can significantly contribute to the development of projects focused on the production of green hydrogen in a decentralised system. The disclosure of potential and available locations over time can be compared with competitive solutions in terms of spatial planning, environmental and societal impact, and the economics of the undertaking.