Sam Massell was seen by many in the Georgia metropolis as paving the way for better representation of women and minorities in city government