Stephen Flynn sparked an internal party backlash after announcing his intention to sit in both Holyrood and Westminster