If I remember correctly the Aldini Production, which is probably still sold by Mak or UF Grant or someone, is the one with the round base on tripod legs, and a square, open top 'tube' in which the bowl appears after a preliminary production of silks, spring flowers, rubber...um..items, etc. It doesn't use a trap door per se but if you saw the gimmick exposed that's what it might look like at first.
Other productions I'm aware of:
1. the one in Al Barkers Ways and Means, which is very nice but requires a specific magic prop bowl which I'm not sure if it's still available. I had one in the 1970's and it was really nice.
2. standalone table production which uses some sort of gimmicked table. GEM magic sold one I believe and others probably still do.
3. Grants "Magicians Dream Production" which produces 3 bowls, one of which can be full of water.
4. Grants Nu Way Kuma Tubes produce 2 spherical fishbowls as a finale.
Having been a fan of bowl productions as a kid I spent some time fiddling with them. Few of the gimmicked ones can really compare with a barehanded production from under a foulard, as people seem to understand the inherent difficulty of producing something filled with water. In the old days this was done with a load from the tails area of a suit (I forget the name of the pockets). When I did it I used one of the aforementioned gimmicked bowls which had a fill hole perfect for hanging from a hook, the hook hanging from a homemade 'shoulder holster'. Most productions which use body loads are done early in the act for obvious reasons.
Tip: though I never did it, I was told you can cut little slips of carrot into fish shapes and they look like goldfish from a distance.