Once-in-a-lifetime reservoir project will slake fast-growing region’s thirst for more water