Kevin Hedgpeth resigned Friday from the Hanahan City Council and his role as mayor pro tem as he faces federal charges