Ancient brook in Coventry city centre is flowing again after more than a century as part of £6m project