@kiki &
@Jenny -- You'll probably want something showier, but I'm a big fan of native plants; most native species of rose are very fragrant, even though they are single-flowered and mostly pink
The tradeoff is a low-fuss, hardy plant with easy access for pollinators. I have a nice
Rosa carolina in my Minnesota side yard; mowing keeps suckers in check. The scent is heavenly for the ~3 weeks bloom.
Another option: My girlfriend "inherited" a William Baffin (old-fashioned semi-double climber/pillar rose) at her rental place, and it's done really well despite getting relocated in a July heatwave. Very cold hardy, long bloom time; plus, it's fragrant! Wish I knew a few more to recommend.
Crossing my fingers that the Japanese beetles are confused in their timing again this year. They were too late for my flowers last summer!