A state-appointed North Carolina elections official resigned from his post on Thursday, officials said, after he was arrested and accused of spiking his granddaughters’ ice cream with illicit narcotics