TRANSCEND Project Tackles Water Scarcity and Climate Change Challenges