Combating Water Scarcity and Embracing Conservation with Sustainable Reservoirs for Responsible Water Resource Management