Novel framework to improve water management adaptation under climate change scenarios