Don’t be embarrassed to talk about failure, councils told