Birmingham City Council leader John Clancy has resigned tonight following controversy over the bin dispute.