I would doubt that anyone would take a holiday in either Peterborough or Huntingdon. Both are beautiful and both have exceptional places of interest close by but neither offers much in the way of holiday accommodation and neither are very close to the coast.
As for Peterborough being under water in the future - well a few million years ago it was under water. If it is to flood again, the most likely cause would we be flooding from the Wash. That would mean a good few towns nearer to the Wash would flood first (Boston, Spalding, Crowland) and huntingdon would not be far behind. If, on the other hand the flood was to be from the river over-flowing onto the fens (as it has done in the past) then Huntingdon would not escape as the same river flows through both cities! I have seen Huntingdon suffering flooding from the river overflowing at the same time as Peterborough.