Assessing water futures under alternative climate and management scenarios