Belfast native Van Morrison has been given a British knighthood by Queen Elizabeth for his services to music and tourism in Northern Ireland.