I have heard of such products as "Weld On" to bond acrylic, but I haven't been able to locate it. Anyone know where I could find this? Other suggestions would be nice as well, as I'm sure there are other products fit for the project.
WeldOn is one of the most common solvent cement. Check for them in sign shop or plastic shop. HomeBase used to carry a comparable solvent cement in brown bottle, but after it went out of business, its competitor, HomeDepot, does not seem to carry it.
There are many, many different types of Weld-on for bonding different plastics as well. My eyes have crossed seeing the RC guys throw numbers around. Depending on the strength you require for what you're sealing, you might want to carefully choose your cement.
For most aquarium acrylic projects, I would recommend to you Weld-On #4 or MC-Bond. Where you are connecting acrylic with PVC, use Weld-On #40. I try to stay away from Weld-On #16.