Charming Hostess band leader was fixture of avant-garde, experimental music scenes in San Francisco and New York since 1990s