A “showcase event” at a major Wiltshire attraction will be cancelled this weekend due to heavy weather brought by Storm Bert.