Star-forming accretion flows and the low-luminosity nuclei of giant elliptical galaxies