This year's top spot was praised for its 'characterful riverside location'