The reason that a 'normal' fluid has zero velocity at the wall is because at molecular scale a wall is not flat at all. The bumpiness of the solid at micro (or even lower?) scale is causing the fluid to stagnate.
That said, laminar flow does not notice a change in wall roughness, i.e. the friction force is not influenced by how rough the surface is. Of course, you can make the roughness elements very big, but at a certain moment the laminar flow trips to turbulence (or, at extremely low velocities, the flow can not really be said to be along a 'flat' surface)
For turbulent boundary layer there is a roughness below which the surface is called hydrodynamically smooth (for which I could not find a wiki reference, it is only referenced as 'hydraulically smooth flow' in the article about the '
law of the wall', which is about a part of the turbulent boundary layer, but the wikipedia for that reference does not yet exist though...). This means roughness has no influence on how large the friction becomes. Or in other words: polishing the surface to a roughness below the roughness at which the boundary layer flow becomes hydrodynamically smooth will not reduce the friction.
But if the roughness elements becomes higher than, roughly speaking, the 'laminar sublayer' (the inner most part of a turbulent boundary layer, see the 'law of the wall' wiki page I refered to earlier) then the roughness will have an influence and will make the friction increase.
Do notice however that I do
not say roughness has no influence, it is what causes the no-slip boundary condition. What I say is that for a laminar boundary layer and for a turbulent boundary layer that is hydrodynamically smooth, a
change in roughness will
not cause a
change in friction force.
Also, if you want to compute the actual friction between a wall and a fluid for a hydrodynamically smooth surface, all you need to know is the viscosity and velocity gradient
at the wall (so you need to know the velocity profile of the fluid up onto the wall). So you don't need to know anything about the state of the surface of the solid.
To my best knowledge, even if the surface would be smooth up to the atomic scale, it will still behave as a no-slip surface for 'normal' fluids. This is also because there are attractive and repulsive forces between the fluid molecules and the solid molecules (Adhesive forces? But molecular dynamics is really outside of my area of knowledge).
I find it a bit unhelpful, maybe even confusing, to make a distinction between
1) The fluid friction between the stagnant part of the fluid at the wall and the fluid right next to it
and
2) The friction between that same stagnant fluid and the wall.
This is because in fluid dynamics (and actually also in solid mechanics) you make the assumption of a
continnuum for a fluid. This model makes this stagnant fluid layer infinitesimally thin. So you can not really identify it as a 'layer' and distinguish it from the rest. So for me they are kind of the same thing. For me there is just friction between the fluid and the wall, and from that point on there is only friction that is internal to the fluid which changes continuously through the fluid domain (if it changes, which it usually does).
ps: by 'normal' fluids I mean the things that we normally associate with a fluid, water, air, alcohol, oil, etc. Not things like clay, starch, emulsions etc.