Normally for drinking gourd you would cut a hole from where you plan to drink, but when I was a kid people made them into birdhouses.
You likely need to condition the inside to waterproof it much like for a waterskin. If you can’t find drinking gourd DIY try looking for waterskin to find a source you can ask.