The League of Gentlemen and Inside No 9 co-creator has always displayed a sense of gothic unease, and his new book combines myth, memoir – and his own disquieting drawings ...