We also like the old-fashioned roses, but surprise, surprise, Rosa rugosa is not a native to North America. The Lady Bird Johnson Wildflower Center, home of Mr. Smarty Plants, is dedicated to the growth, propagation and protection of plants native only to North America but to the area in which those plant grow naturally. The reason for this is that plants that have grown for centuries in the same soils, climate and rainfall will require far fewer resources to prosper.
We do have a National Suppliers Directory, which you might try, as most of them are not restricted entirely to native plants. Enter your town and state or just your zip code in the "Enter Search Location" box, and you will get list of native plant nurseries, seed suppliers and consultants in your general area. You might also try the Antique Rose Emporium in Brenham, TX. We became addicted to them while living in Brenham some years ago, but did understand that "antique" did not mean "native."
If you follow the Rosa rugosa link, you will get a page with lots of information on this plant, including that it is native to China, Korea and Japan. Unfortunately, that is no help in determining how the rose would do in Hood County.