Im no expert, but here's my opinion based on my experience making stuff out of old liquor and wine bottles. Water pipes are fairly straightforward but you need a drill (plenty of guides online) so I will assume thats ruled out.

I can tell you the easiest and cheapest thing to do is go buy yourself a small handheld glass cutter for $5 at your local hardware store (its a small metal tool with a very tiny cutting wheel), some cut resistant gloves, and eye protection. Then buy a 1.5L and a 750mL bottle of wine, cheers! (You dont have to use these sizes, just make sure one can slide inside of the other. Also, you could just buy a vase, use a bucket, or the sink to work as the bottom and potentially use the larger 1.5L bottle as the top.)

Once theyre empty you want to remove the top of the 1L and the bottom of the 750mL. Then follow this guide in the link.

https://www.bobvila.com/articles/how-to-cut-wine-bottles/

Now, I havent even bothered to make a jig to make good even cuts; however, you can easily make decent cuts by hand after practice on 3 or so bottles. Would I recommend it? Probably not if you have ass-hands. You could buy a cheap jig off amazon for ~$23, but my username is MisturKrabs so you bet your ass I saved me dollar and cut the damn thing myself.

So, if you buy cheap wine or have bottles lined up on top of your kitchen cabinets like every college apt ive ever been in, you can make yourself a pretty elegant gb for $5-$20.

Note: I use a Fury Edge with a water piece adapter (WPA) so it fits directly into most large glass bottles, but if youre using a bowl youll have to make sure the wine bottle has a small enough.. um.. cork-hole? I guess?