Feared in America as the Satan-worshipper who inspired the Columbine massacre, but widely regarded elsewhere as a camp standard-bearer for goth culture, Marilyn Manson talks about marriage breakups, murder and makeup