A beloved doctor who was killed in South Carolina in a shooting is remembered for his deep involvement in the community