A cash-strapped council is to introduce overnight stays for motorhome users in one of its country parks to raise funds.