Opening the “black box” of decision-making for climate change adaptation at the local level