Emergency water restrictions put in place to ensure Brisbane's drinking supplies didn't run out have been removed over night.