No. Random dungeons will not progress the campaign in any way. This means they do not trigger road or city events, unlock new scenarios, gain town prosperity or anything else that would impact the campaign world. They can, however, help with character progression, in the form of experience, gold, checks, and personal quests.