The painting, "Portrait of Charlotte Cram" fills a major gap in museum's collection and should become a visitor favorite, officials say