From Bologna's medieval lanes of mortadella and fresh pasta to a Rotterdam market hall whose ceiling is a giant mural of fruit and vegetables