Depends on what you think is "scenic" but, yeah, there are some beautiful landscapes plus lots of high points from which to view them. Here's a couple shots I took when returning to Windhelm from different locations.
[img]http://img441.imageshack.us/img441/6312/3mouseketeers.jpg[/img]
[img]http://img207.imageshack.us/img207/8741/approachingwindhelm.jpg[/img]
That's obviously not the greenest part of Skyrim, but I like snowy mountaintops. For forest you'll want to venture into Falkreath or the Rift, for mountains minus the snow there's the Reach, for wide open tundra there's Whiterun. And Solitude's not my favorite city, but it's hard to beat for a scenic location:
[img]http://www.plughead.net/wp-content/uploads/2011/11/Skyrim-Solitude.jpg[/img]