A detective responsible for investigating race-hate crime, who was exposed by the Telegraph as being married to a British National Party member and living in a shrine to Hitler, has resigned from her post.