Former deputy first minister of Scotland from Orkney chosen for key role within the Church of Scotland