it's called a strain name

and the thing going from the piep to the bottle is a tube/hose

if you just stuck the pipe in the side of the bottle and filled it with water it either wouldn't work or, more likely, would fill your pipe and bowl up with water and probably get everywhere..

for tubing you could either go to a home improvement store or a pet store, both carry it, and it's pretty cheap.... for the minimal ammount you'd need, if they sell it by the foot you'd probably pay less hten a dollar...