PVC is easy to work with. You do not need anything special for the aquarium. You will just use the same stuf that you would use for home plumbing.
You need to get the primer/cleaner, usually purple. You will also need the cement. Cut your pieces to the desired length. Deburr the edges. Then you need to prime the inside of the coupler, elbow, tee, etc.... and prime the outside of the pipe. Prime the surfaces that will be touching, usually about 2-3 inches back from the end is good. Let the primer dry. Then I use cement on both surfaces as well. Slide the two pieces to gether and give them a little twist back and fourth. Do it quick, because after 10-20 seconds the cement will be hard and you will not be able to move anything. Wipe down the finished joint to get off excess glue. Thats it........run water through the plumbing to clean it up.