The former first minister’s funeral will be held in his Aberdeenshire hometown on Tuesday afternoon