Rebekah Brooks, arguably the public face of the phone hacking scandal, has resigned as chief executive of News International.