The forecaster warns of 'heavy downpours and thunderstorms' across most of the nation as welcome rain will soak many areas