Bound for Portugal’s second city? From luxury suites to rooms with views over the River Douro, these are the very best places to bed down