Ripon could get ‘transformational’ hub to boost transport