I once took part in a triathlon(sp?) where the swimming event took place in Loch Ness.
Yes, it's cold, but at long as you get yourself ready beforehand and keep yourself moving in and out of the water it's not unbearable.