Update the local dev environment to replicate our monitoring setup

Originally created by @intrigeri on #9485 (Redmine)

This should be done with Puppet, once #9483 (closed) is done. The idea is to enable DrWhax to contribute fixes/improvements later on, which is needed given he’s responsible to deliver a working configuration.

Parent Task: #5734 (closed)