AI-Powered Sewer Systems: Boosting Climate Resilience in City Water Managem