A village on the Northumberland coast has been named Britain’s best seaside resort for the second year in a row.