Joe Tate's return to the fictional Yorkshire village spells trouble for the iconic character