Murray Harkin, managing director of R-JH Public Relations, has resigned over the "Sophie tapes" scandal.