A frantic search is underway for two children missing in a river in a major Australian city after a woman tragically drowned.