Jane Campion's work on The Piano produced a rare female nominee of the Academy Award for Best Director, writes Esther McCarthy