The shepherd killed himself by hanging a rope from his water truck on the desert road near Dammam airport