Known for his charity work and kindness, Stephen Gately was also praised as a "gay rights hero"