Tate Britain brings together the menacing figures and erotic interiors of the notorious Victorian illustrator