The couple left an indelible mark on Charleston culture, paving the way for modern art in the Lowcountry