More funding is needed to avoid a “severe impact” on services and more councils going bust, a report says.