Councils face 'decades more austerity' as social care set to account for half of town hall revenues