The former boss of Stirling Council has been appointed as the SNP’s interim chief executive just weeks after she was forced to apologise for sharing “shameful” remarks about the Royal Family.