White oak is one of the most rot/water resistance woods, red oak is not the greatest around water and water vapor. That being said nearly any wood will work great if it is sealed well.

Use what...