"Mary Magdalene in Ecstasy" is the gallery's first work by the Italian artist, who was one of the most influential female painters of her time