Move auth to Grafana instead of puppet

This ticket tracks moving authentication out of puppet for Grafana. In #40102 (closed) we created a shared account for people accessing Grafana. This doesn't really scale and it would be nice if we could create accounts in Grafana directly.