From creation myths to gender politics, artist Melanie Jackson and academic Esther Leslie investigate that most indispensable of substances