Literally, 'pay a visit' means the same thing as 'visit' - to go and see somebody or something. However, there is a slight difference in normal usage.
If someone says they are going to pay somebody a visit, it usually implies some specific purpose.
In any sort of drama, of someone talks about paying somebody else a visit, it almost certainly implies that the visit will be unpleasant, either asking that person some questions they probably have reason not to answer, or, at worst, threatening them or harming them.
In the case above, the meaning is neutral. The speaker is going to visit MI6 to get some important needed information. The visit looks like it will be polite, but very serious.