A call for a formal seasonal Pembrokeshire campsite with motorhomes camping on the site of a former scrapyard has been given the go-ahead by national park planners.