The SNP has been accused of squandering public cash after spending more than £500,000 on consultants to advise on cost-cutting changes to the NHS.