Non-trivial solutions of local and non-local Neumann boundary-value problems