This mod changes the gourd's model and texture with ones based off of a butternut squash, because the vanilla one didn't look remotely edible - appropriate since it's called a gourd, not a squash as it should (people usually refer to edible gourds as squashes).

Before/After screens in the image section.

You can choose from a version with just the model change, or a version that adds several squash recipes that you've probably eaten at Thanksgiving at some point and changes the name of the item to Squash.

Squash model from here, used with permission.