Sounds like you’re talking about Sherlock Holmes series by Sir Arthur Conan Doyle! Deerstalker hat and opium addiction are dead giveaways. The story with the dog is 'The Adventure of Silver Blaze'. Classic stuff, you gotta read it again!