Peter Murrell and Nicola Sturgeon were once the SNP’s power couple