Refurbished museum has also announced shows of female photographers Yevonde, Francesca Woodman and Julia Margaret Cameron and will see the return of David Hockney