Whatever weather app you're using has to support it. Then:
Settings - Notifications
Find the app listing and add it to the Notification Center, choosing your options for the alerts.
There are others but The Weather Channel and Intellicast HD apps support alerts.