A town's fountain is finally flowing ahead of its official opening by celebrity gardener Alan Titchmarsh.