Energy Transition in Urban Water Infrastructures towards Sustainable Cities