The EuPRAXIA EU project is at the forefront of advancing particle accelerator research and the development of photon sources through innovative plasma acceleration approaches. Within this framework, the EuAPS project aims to exploit laser wakefield acceleration to build and operate a betatron radiation source at the INFN Frascati National Laboratory. The EuAPS source will provide femtosecond X-ray pulses in the spectral region between about 1 and 10 keV, unlocking a realm of experimental ultrafast methodologies encompassing diverse imaging and X-ray spectroscopy techniques. This paper presents a description of the EuAPS betatron source, including simulations of the photon beam parameters, outlines the preliminary design of the dedicated photon beamline, and provides an insightful overview of its photon science applications.