An MP has called on a council to reinvest the money it received from a film production in the town where it was shot.