Impressive showcase of museum's Modernist photography collection provides opportunity to expand holdings of key female artists active in first half of 20th century