Sources say the ‘majority’ of the SNP’s national executive are against double-jobbing in Westminster and Holyrood.