We report on the development of a hypocycloidal-core Kagome hollow-core photonic crystal fiber guiding, with low transmission loss in the 450-650 nm visible spectral range. Transmission loss records have been achieved with 70 dB/km at 600 nm, and 130 dB/km at 532 nm. As a demonstration of the fiber potential applications, we report on a compact 600 THz wide Raman comb generator, centered around 532 nm, and on a 10 W average power frequency-doubled Yb-fiber picosecond laser beam delivery, along with its use for organic material laser micro-processing.