The Angus North and Mearns SNP MSP is to stand down after 10 years.