Advancing a transdisciplinary approach for a paradigm shift in water management in US cities