Hey.......don't knock the 2 part epoxy, that stuff rocks. I used it to seal my pond over flow in my paludarium so the coco fiber wouldn't erode away and sherry is correct, silicone will cure with a hazy film which will get more opaque the longer water runs over it. Take a look at the seams on a tank to get an idea of what it will look like.