White Oak, Mahogany, and/or Marine Ply are the usual suspects for transom construction.
One can step up or down from that set with the more expensive Coosa Blueboard or the less expensive Exterior Ply.
For what it's worth, Red Oak is not recommended for boat building as it has a cellular...