The leader of Edinburgh City Council has resigned amid allegations of alleged inappropriate behaviour.