Does it leak at all? Also, does it come with that pipe?

Thanks,
Shaun