A new award has been created in memory of a visionary tourism and hospitality leader who ran the Celtic Manor Resort.