The federal and Alberta governments have signed an agreement to allow municipalities across the province to access hundreds of millions of dollars to invest in water and infrastructure and spur new housing developments.