Many local authorities are plunging into the red to meet their obligations as spending trebles in three years