The much-loved author talks about seeing American Gods adapted for TV, his love for Norse mythology – and his many other projects