The former first minister will be flown to Aberdeen, near to the home he shared with wife Moria for 30 years.