If you don't have firm principles on this subject ahead of time, the winds that surface at the time'll likely blow you about. The individual should be our first concern, not a set of rules. If we don't use them they'll just switch to XYZ church and be fully accepted. These and other arguments will surely emerge when you face your first affair among the leadership in your church. If you do not have a set of principles, these winds will blow you one way and then another.
Some denominations have clear principles and procedures.
I don't want to pre-empt the making of your own list of principles, but here is the list I am working from. A person must leave leadership after an affair. I'll even get voted out over this one. Adultery and gossip are not equal. The reputation of the church is a consideration too.