Yes, all of the water in Banff is rated as high quality groundwater by environment Alberta. It tastes great and there are plenty of refill fountains around town, so make sure you bring your water bottles!
More details are available on the Town of Banff website: banff.ca/Drinking-Water