UK’s big two suffer Brexit backlash in local elections