Cathedral canon chancellor resigns over eviction threats