Impact of climate change on water resources, challenges and mitigation strategies to achieve sustainable development goals