There are quite a few salts that get cold when they dissolve in water, but then you are left with the problem of salts or very high concentration salt solutions on your skin which can osmotically pull water out, drying and cracking the skin beneath.
The best cooling effect would be from something that evaporates quickly (like isopropanol) or that is pleasantly cool without adding salts (like, say, a cool spray of water?)