Sounds like a job for an industrial programmable device like a PLC or RTU.. ie not a cheap item.
It may be possible to build a dedicated device based on a PIC microcontroller, but if you want someone to design and build one for you its not a trivial ask
Whats the budget for this?
P.S. I have built monitoring/control setups around kingfisher RTU's, but not PIC or PLC so I cant help with this.