For the base connection, you can do it two ways as used in commercial construction:
4 cast-in-place bolts with leveling nuts for plumbness adjustability. This is usually used on building main columns. The baseplates are recessed about 8" on a diamond leave-out. After erection, they grout the underside with non-shrink grout, then they'll come and fill that with concrete and leaves a nice finish w/o bolts exposed. Drill a hole on the bottom of the post at grade elevation, then fill it with non-shrink grout. Any condensation will weep out.
Another way is to have the bolts exposed like they do on lightpoles. Just as before, but not recessing the bolts.
On our projects we have a note that tells the contractor to use a plywood template matching the baseplate to set the anchor bolts.
Different ways to do the top as well.
1. A single vertical shear tab down the center of the wood beams with holes punched out for bolts would look very clean. You'll have to kerf the wood beam the thickness of the shear tab.
2. angles to act as corbels will also work, but you still have to brace the beam so it doesn't rotate and won't look as clean.
Basically, many ways to skin a cat...
5-6" steel tube seems appropriate for this, and will look nice and be close to a 4" nominal wide wood beam (I'm assuming you are using wood beams, right?). 2" is way too slender. Even it works (I doubt it), it will look like linguini and scale would be off.