Set against the 17th-century splendour of the Euston estate, Red Rooster has always been a celebration of rootsy Americana