i don't think it is possible. you can of course mix certain products to form a stable emulsion (as in a lot of metalworking fluids), but then the lubricant does not separate from the water afterwards as you wish. is it lubrication you are after or rust prevention? normally a wet metal component is dipped or sprayed with a water repellent corrosion preventive that repells the water on the metal surface but gives only a rather limited protection. for longer protection another thicker rustpreventive usually is employed that adheres better to the metal surface, but is less good in chasing the water away.