Flood alerts for north-east, Western Isles and southern Highlands as wet weather hits