Cissy was a founding member of R&B group The Sweet Inspirations and performed alongside some of the greatest artists in the industry, including Elvis Presley