I came across a pretty good weather widget
they have a free version too, check it out
Animated Weather for Android - Weather forecast application. The exquisitely realistic video effects of cloudiness, rain and snow provide the vivid sensation of current or future weather conditions for more than 50000 locations over the world.
Android Weather Widget - Android Weather Widget - Best Animated App
Video:
YouTube - Animated Weather Forecast App For Android Free Realistic Weather Forecast on Your Android.avi