The Rock & Roll Hall of Famer is gifting a need-based music scholarship to the University of Michigan