You can use canned pumpkin or a freshly pureed sugar pie pumpkin. To use fresh pumpkin, preheat your oven to 400 degrees Fahrenheit. Cut the pumpkin in half and scoop out the stringy fibers and the seeds. Place face down on a baking sheet and put in the oven for 40 minutes or until you can insert a fork into the skin. Take the pumpkin halves out of the oven and let them cool for a few minutes. Scoop out the pumpkin flesh (don't get any of the skin) and put it into a food processor or blender. Pulse/blend until smooth. You can store it in the fridge in an air tight container or freeze it.
1/4 cup honey is a lot so you can reduce it if you want. However, I’ve played around with the amount of honey a lot and 1/4 cup honey gets you the best tasting drink.
*Previously I claimed that you can use canned pumpkin. However, I finally did use it for the first time and it was awful tasting, so I don't recommend it.