A much-loved North East café which has been a favourite for locals has announced it has closed its doors for good after seven years.