The son of late actor Sir Sean Connery has invested £1 million in an inland surf park.