Yes, it can mean "(It's so nice, a fanciful thing ) to see you here.," but it can also be used sarcastically or with irony.
For example, if you see someone who never exercises at the gym, working out, you may say, "Fancy seeing you here." It really meas, "I thought I'd never see you here today!"