Sierra Leone needs "urgent support" now for thousands of people hit by mudslides and massive flooding in the capital, the country's president says.