The software is the same at its core.
But OnDemand/Cloud is a "managed service" - you sign up and that's it, you don't have to think about servers, infrastructure, backups, upgrades or maintenance. (On the point about upgrades, Atlassian release to Cloud when their code is ready, so it's usually ahead of the latest on-premise download). You still need admins, but the low-level "provide a Jira" stuff is done for you.
You are limited on Cloud though - there's a short list of addons you can add, and you cannot customise any code. You're restricted to running it within certain boundaries.
In 2014 it was true, that Agile Poker for JIRA wasn't available in JIRA Cloud but since May 2016 it's no longer the case. If you are still interested in this add-on take a look at it on Atlassian Marketplace and check out the 2min video below:
Mateusz - Agile Poker for JIRA developer
Hi Atlassian community, My name is Max and I work on the product integration team at Atlassian. I am pleased to announce the early access program for the Jira Cloud add-in for Outlook. This add-in...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events