How can I modify the appearance of Melon vines?

According to the wiki, the texture is offset underground then extended up as the melon (or pumpkin) stem grows. It's just a matter of making sure the stem texture is tall enough.