The SNP's arguments are deceptive and amount to scare-mongering, former SNP deputy leader Jim Sillars tells CNBC.