Sometimes would be nice to hover over land of Skyrim and watch everything from above or even take some pictures of cities and places from sky. But how to do that?

Best way to fly around like a bird is to enable free camera moves. That will allow to freely move around and observe everything from above, like bird flying over Skyrim.