This font is called Berliner, but I think it was modified for the album cover of Holy Wood.

Also look under the Gothic/Medieval category. Here I made it a bit easier for you to search.
http://www.dafont.com/theme.php?cat=401&text=mm+marilyn+manson&fpp=100