You wont be able to see the join!
It has been built over by British Rail and recently by new housing, but the original section went 'inland' through what is now the marina at Concoform (where we keep Dabchick). There is a considerable amount of information available about the Barracks (Google Weedon Barracks history) including a 140-page detailed history relating to proposals to develop the site.
There is a recently-developed (well, 10 years old) housing development at Cavalry Fields which abuts the Depot. Interestingly, this development mirrors much of the original architecture of the Depot.
There were plans to have the National Fire Service Museum here, but those plans were recently abandoned.
Much of the site is listed and I found a considerable number of links via Daventry district Council Planning Applications portal - too many to list here but gives you an idea!