The Caravan and Motorhome Club says the site will bring "significant economic benefits" to the area.