The embattled South Carolina attorney has been charged with two counts of murder and two counts of possession of a weapon during the commission of a violent crime