A state-of-the-art driving range, bowling alley and sports bar will open at Ramside Hall this year as part of a £6m investment.