From Beethoven to bebop to his own abrasive, atonal ‘noise band’, the now revered artist tuned his work to music at every turn of his career, as a major new show reveals