The duke in his book Spare made reference to taking cocaine, marijuana and psychedelic mushrooms