Voters in Burnley have made the British National Party their official opposition – but in Sunderland the far-right party was soundly rejected. Daniel Martin assesses its standing following Thursday's elections