A motorboat has sunk in a Brazilian river, killing two children and two adults, and leaving three people missing.