Resource availability and heterogeneity shape the self-organization of regular spatial patterning