A new café bar at a landmark site outside Caerphilly Castle has opened its doors to the public.