Scotland’s drug and alcohol deaths remain among the worst in Europe despite increased spending to tackle the problems, a significant report by auditors has found.