Not sure about octopus, but dolphins do get high on pufferfish - http://www.smithsonianmag.com/smart-news/dolphins-seem-to-us...

"Pufferfish produce a potent defensive chemical, which they eject when threatened. In small enough doses, however, the toxin seems to induce "a trance-like state" in dolphins that come into contact with it"