Dean-Kawasaki Equation with Singular Non-local Interactions: Well-posedness and Large Deviations