Council leaders have told The Sunday Telegraph they are preparing for heavy losses in the local elections, amid fears voters are turning on the party for failing to take the UK out of the European Union on time.