Spending on things related to climate change is "not optional" for Cambridgeshire County Council, the leader of the authority has said.