The chancellor of St Paul’s Cathedral has resigned from his post in a row over anti-capitalist protesters occupying the churchyard.