Thousands of visitors are expected to attend a sound and light show which is set to illuminate the interior of a cathedral.