The scheme is expected to create 50 direct jobs, but similar investments in the south of England are said to have created up to 4,100 indirect jobs