How big do you want the gourd to be? And please edit your thread subject with the series name, character, and prop name for easier referencing.
Face paint will work, but it tends to smudge with water. If you want something that is more durable (and likely to last a couple of days after), you can consider airbrushing.