Councils on 'financial cliff edge' due to rising numbers of