A local coffee shop is set to be transformed into a family friendly gourmet deli and pizzeria after being sold to new owners.