SNP Westminster leader Stephen Flynn's plan to launch a parallel career at Holyrood has sparked new controversy in a party which already has more than its share of troubles.