“He was a kind, generous soul who loved his fans, his family, his friends, and his music with everything he had,” family says