I think you are looking for Al-Ghariya Resort.

It is towards Al-Ruwais, follow the sign boards after Al-Khor Exit.