Sunderland chief executive Margaret Byrne has resigned in the wake of the Adam Johnson child sex abuse case admitting "a serious error of judgement".