Artificial Intelligence Aided Resilient And Sustainable Water Infrastructure Systems