I use this Hubitat weather driver which leads to a pretty nice looking weather tile (IMO). I tried to document how to set it up here. It results in a tile like this one:
I also use a radar image tile that updates every few minutes (the URL is in one of the built-in examples).
Another option is to search for a local TV station weather image that updates.. for example there's a 7-day forecast that I found for Charlotte here. They have several images at the bottom that keep updating so I'll add the URL in an image tile with some 5 or 15 minute refresh rate.
