Facing a hotter, drier future, seven states recently signed an extensive new water management agreement for the Colorado River reservoirs