A landmark new urban park in a North East town is set to welcome its first visitors this weekend, marking the end of a five-year regeneration project.