Pierced by pins, tormented by ravens, obscured by bathtub bubbles … the great Japanese photographer created astonishing, disturbing and highly personal images of himself, his family – and his beloved cat Sasuke the Second