Millions of people will be able to set their own contactless card payment limits or even have no limit at all, a regulator has confirmed.