In the article "Moving Pictures" from SkyWatch 2012, Lorenzo Comolli and Alessandro Gambaro explain in detail how to create time-lapse movies of the sky and other night scenes with a digital camera. Some of the authors' best videos are available on their website (click on AstroVideos in the left margin).
Time-lapse skyscape videos have mushroomed in the short time since this article was originally published in the August 2009 issue of Sky & Telescope. Some of the finest examples we've seen are listed below.
Check out also the huge collection of videos on The World at Night website.