You can put a tent in the RV spots. Prices change based on the season. Sites, when we were there in July, started at $95 a night up to $1,000. https://www.newportdunes.com/experiences/water-park/
No tent camping, they do have cottages you can rent or RV spaces. I don't know how much the cottages are but the 40' RV lot was about $200 a night.
Thanks! Your answer is awaiting moderation.