You can't pipe cold water through radiators, all you'll get is a very wet floor. Think of an ice cold bottle of beer.

You need a radiator with a built-in electric fan, this will all but eliminate the condensation.

However it will not cool like an A/C unit, only something like 5°C reduction. This can be enough to get a decent night's sleep during a summer heatwave.