As the SNP’s long-standing chief executive, Murrell oversaw the party’s rocketing rise in popularity and a large influx of new members