The 23-time Grammy Award-winning musician died of a rare form of cancer that was only discovered recently. He was 79 years old