A former Georgia sheriff resigned from a state watchdog group after a photo of him wearing a KKK robe surfaced