One of the easiest ways to acquire pumpkins is by gathering them yourself at Costa Farm (Southwest of Heidel). It also has a node that you can assign a worker to.

You can find tons of Pumpkin on Elda Farm, just South of Heidel City.