A water pipe has burst on a busy street in York city centre.