Video Nashville mayor resigns after admitting affair with bodyguard