Northern Ireland needs a long-term funding agreement from the UK Government to fix its public services which are in crisis, MPs have warned.