I know the effect you're going for (big stargate fan) and it's a toughie. The movie and tv show actually use actual water video as the main source of their effect (with particles thrown in for effect). Only thing I know to tell you is to keep experiementing. You could perhaps create a cylinder and have the particles collide with it, but make it completely transparant so it won't render.