Warwickshire County Council's chairman resigns after being exposed as a "rogue landlord"