Divergent effects of climate change on future groundwater availability in key mid-latitude aquifers