A "heavily intoxicated" man was pulled from the River Ouse in York after climbing on to a bridge and diving into the water.