There are some pretty amazing songs about Wizards in rock; 'The Wizard' by Black Sabbath with that fantastic harmonica intro, The Wizard by Uriah Heep, first track of their classic Demons and Wizards album.
Less recognised, however, are the 450 bands (yes, 450..) dedicated to playing nothing but songs about Harry Potter (known as Wizard Rock or WRock). They have names like Draco and the Malfoys, The Remus Lupins, Kingsley and the Shacklebolts, and the Whomping Willows, I think you get the picture. It all started in Massachusetts but has become a world wide phenomenon of Harry-Potter-Rockers. A full-length doco film project , The Wizard Rockumentary: A Movie About Rocking and Rowling premiered Washington this April
More info here