Look for sugar or pie pumpkins, Hokkaido pumpkins, or butternut squash. These have smoother, sweeter flesh ideal for puree