Access to safe, clean, and affordable drinking water is a fundamental right that is essential for public health [1]. However, factors such as global population growth, food demand, industrialization, urbanization, and climate change are posing significant threats to the availability of freshwater resources worldwide [2].Despite efforts to reduce pollution, improve wastewater treatment, and the restore rivers, lakes and reservoirs in China, archiving good quality for water reminds a challenge [3,4]. Poor water quality exacerbates China's water scarcity and regional inequality [5], making it increasingly necessary to rely on reservoirs and lakes with better water quality and inter-regional water transfer projects to meet the demands for drinking water supply [6,7].The Middle-Route of the South-to-North Water Diversion Project of China (SNWDPC) is the world's largest inter-basin water diversion project and has