A long-awaited museum dedicated to telling the stories of Chinese Australian migrants and their role in building the nation has opened its doors.