Detroit police chief retires amid affair allegations