‘Great courage’ hailed as Nicola Sturgeon confirms death of Scottish care worker