A new exhibition explores how the naked form revolutionised painting and sculpture. Cath Pound looks at shifting attitudes and what they reveal about society and sexuality.