It's certainly possible to stay there overnight, but one hotel is outside the main grounds and the other inside it. Neither are cheap. I recommend staying locally and enjoying a bit of Wales as well.