you SHOULD be fine to use acrylic...
but I wouldnt if you can avoid it.
silicone sticks fairly well to acrylic, it wouldnt hold a tank together, but it will still bond to it with a good deal of strength.
but though this is a place where there is very little stress on it; so it would probably hold up fine. it is also a place where failure has major consequences, namely, flooding your house. so the outside chance of a leak it not really worth the risk IMO.
you dont need any crazy strong glass, you could probably get away with the window glass from ace hardware, but on a 6' span, be sure to give it some bracing in the middle.