Ships, sea monsters, seashores, shells, sirens and sea maidens are all to be discovered in vibrant exhibition