The angle of the pipe doesn't matter, the vertical height of the water will tend to be the same in the pipe as it does the "room". Assuming the pipe ends at some point, the water will pour out when the height of the water exceeds the lowest part of the opening at the end of the pipe.