A survey found many Scots remain unconvinced Labour could do a better job in power than the SNP, despite widespread dissatisfaction with the state of public services.