An emergency alert has been issued for Queensland as severe weather unleashes torrential rain and wide-spread flash flooding in the state's north.