Standard 5 minute epoxy like you find at your home repair center is just fine, super glue is excellent. If you look on the reef sites, you'll find much discussion of adhesives as they've pretty much tried everything... There are very few epoxy's and superglues that aren't fish-safe - and they all cost extra (for anti-mildew, anti-fungal etc properties) so if you buy the cheap stuff - you'll almost definitely be good.
Andy