Self-tuning to the Hopf bifurcation in fluctuating systems