Roland the Headless Thompson Gunner was written by Warren Zevon, author of "Werewolves of London", and is on his "Excitable Boy" album. Try looking in

http://www.vhf.com/~kennyb/lyrics.htm

under Warren Zevon (I haven't, so I don't know if it's there but that site has links to lots of other rock music sites).