One of my favorite topics...
I designed an office space from scratch when I opened up my first office. It was previously a retail space, about 2,000 sf, that we completely gutted down to the bare walls.
I have four private offices for top-producers. These sat empty for a while as I wanted some leverage when I was recruiting talent from other companies. Now, they are all full and I plan to re-assign them at the beginning of each year to the four top-producing agents. It has become a real incentive for those individuals to keep producing, which makes me happy.
I also have an agent bullpen area which is equipped with very basic cubicles. These I got for free from Blue Cross when they were re-doing their offices, which was a savings of about $10,000 (you can ALWAYS score free office furniture from a variety of sources if you're resourceful). All newly licensed agents get assigned space here, knowing that they can "move up" to a private office if they are in the top 4. My listing input person occupies one of these cubes, also.
Aside from that, we have a front-desk area where the on-duty or "floor" agents sits. He or she is able to greet clients or customers upon entering the door. We have a lot of walk-in business here, so this area was designed around that. This area is surrounded by a resource area complete with networked color-laser printers, fax, scanner, hi-volume copier, etc. It works pretty well for us.
To round it out, we have a large conference room with a 10-foot table. We can seat 10-15 in there comfortably for meetings and such. There is also a nice waiting area / property display area up front too.
I figured my own office into the equation, too. I figured I needed a place to hang my hat and store confidential files, etc. It gets used a lot.
I wish we had more room, though. We're already 100% full. We can double up on desks, etc. if we have too, though.
Hope this helps. It you don't have walk-in business then you can get away with executive suites, etc. Here, it was critical to have a walk-in friendly office where the agents would feel comfortable spending their office time. Of course, I didn't want to make it TOO comfortable because we all want our agents out there listing and selling!