Upvote:0
For public transport information Google Maps is indispensable. It has access to bus and train timetables in every city I've been to. Do use with a bit of care of course. However it can only show you how to go somewhere if you know you want to go there. It does require data access at least at the start of your journey.
The TripAdvisor city guides are quite good at showing you what you can visit, they often provide a kind of "tour" of what's there.
Upvote:1
Try these apps, they in English. Most popular, I some used - "Ask a nomad", "Tripadvisor offline city guides", "Localscope", "Tagwhat", "Now", "Numbeo"