Collective Hamiltonians in the generator coordinate method: Isoscalar monopole vibrations in light spherical nuclei