You could build an acrylic cylinder in the center of your tank as an overflow and achieve that effect.