The SNP Westminster leader will not stand for the Aberdeen South and North Kincardine seat at Holyrood while remaining an MP.