The former boss of Stirling Council has been appointed as the SNP’s interim chief executive after the resignation of Murray Foote.