Personally, about a foot is good. It lets you get plenty of filtration, and a big enough chamber that when you slide out the bowl, you really get a helluva hit.

Now don't get me wrong, a 6-foot acrylic hookah with four tubes and a stepstool for the guy with the lighter has its place, but....