Local authorities across Scotland have paid out more than half a billion pounds putting homeless people in temporary accommodation in the last five years.