Councils in Scotland have spent more than £400 million in the past five years on social care overtime and agency staff, figures show..