The drummer's pictures and artifacts are the subject of a new exhibition, 'A View From the Throne,' in San Francisco