The future of two key tourism sites in a county could be secured with an £800,000 investment, a combined authority has said.