Al Khafji is in the border of KSA and Kuwait and they have big operations of Arabian Oil Company . Many employees of this company travel from Kuwait also. Not much of social life there . Very long drive from the nearest airport Dammam with (if I remember correctly) > 100 km stretch of single road (dual traffic) . I am not sure if same is the situation now also. No news about schooling there when I last visited in 2005.

If you want to move with family , better you stay in Kuwait. Good place for saving as there will be nothing to spend.