Independent coffee shop to form new centrepiece as Waterside owners make £1m-plus investment