For a simple Thanksgiving centerpiece, we have often used the miniature pumpkins.
Just cut a small hole in the top of the mini-pumpkin and scoop out with a spoon. Make sure the hole is only about the size of a quarter, so the candle won't tilt!
Then place other small gourds, squash, etc. around them. It is very harvest-festive!