Leveraging on AI to Transform and Improve Water Management Systems