A private service was held for the Southern rock legend, while thousands of fans lined the streets of Macon, Georgia to pay tribute