I can give you one compound that has a pool with a cooling system - Al Zuhoor. Very nice place. Don't know if there are any openings though.